SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW dbo.vweSSolicitudesSoporte
AS
SELECT     IDSoporte AS ID, IDEquipo AS Referencia, IDTipoSoporte, DescripcionCorta, DescripcionLarga, IDEstado, FechaOkUsuario AS CierreSolicitud
FROM         dbo.Tb_SSolicitudesSoporte

GO
GRANT SELECT ON  [dbo].[vweSSolicitudesSoporte] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweSSolicitudesSoporte] TO [Informatica]
GRANT SELECT ON  [dbo].[vweSSolicitudesSoporte] TO [SoloVer]
GRANT SELECT ON  [dbo].[vweSSolicitudesSoporte] TO [Soporte]
GRANT INSERT ON  [dbo].[vweSSolicitudesSoporte] TO [Soporte]
GRANT DELETE ON  [dbo].[vweSSolicitudesSoporte] TO [Soporte]
GRANT UPDATE ON  [dbo].[vweSSolicitudesSoporte] TO [Soporte]
GO
